2016-09-15 - 28041 - Break Fix - copa report update #CrystalReportsSupport
BREAK FIX
28041 - copa report update
Problem Summary
Need to update COPA reports with customer group 8 and customer group 9 fields.
Admin Info
Purpose
|
Need to update COPA reports with customer group 8 and customer group 9 fields.
|
Requested by
|
Sheila Halloran
|
Issue Date
|
09/15/2016
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
12/31/2016
|
Document Status
|
Complete
|
Detailed Problem Description
IM From Saravanan on 09/15/2016:
Please find the difference between all 7 reports and the only difference will be on the revenue field (last field) but those are for the plant 0586 or for different plant.
Email From Saravanan on 09/16/2016:
Make a copy of those 7 reports, open them and add customer group 8/9 to the report. Save it under dev and let me know the location.
IM From Saravanan on 10/24/2016:
Can you run the copa and glpca reports under dev--> it--> greg for period 9?..take a copy of the report and do the changes to update generalized license in place of consolidated license
..once all 6 copa reports are completed, please open the output (in excel) and combine them into single excel file.
Call From Saravanan on 11/10/2016:
Can you run the copa reports under dev--> it--> greg for period 10?..once all 6 copa reports are completed, please open the output (in excel) and combine them into single excel file.
Solution Analysis and Recommendation
1. Need to check any filters having COPA reports.
2. Need to check 0586 plant data update into the COPA reports.
3. Need update COPA reports with customer group 8 and customer group 9 fields.
4.
Need to validate the reports with BW BEx query.
5. Need to place the report in BI development and inform NEC after successful validation.
6. Need to schedule COPA reports and GLPCA report for Period 09 2016.
7. Need to update generalized license in place of consolidated license in COPA reports.
8. Need to schedule COPA reports and GLPCA report for Period 10 2016.
9. Need to combine all COPA reports into single excel file.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Updated the COPA reports with customer group 8 and customer group 9 fields.
2. V
alidated the reports with BW BEx query.
3. Placed the report in BI development and informed NEC after successful validation.
4. Scheduled COPA and GLPCA reports for Period 09 2016 and combined all COPA reports into a single excel file and sent to NEC.
5. Updated the generalized license in place of consolidated license in all COPA reports.
6. Scheduled COPA and GLPCA reports for Period 10 2016 and combined all COPA reports into a single excel file and sent to NEC.
Release Information
None